package com.woniuxy.main.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.woniuxy.main.pojo.Vi_user_coach;
import com.woniuxy.main.pojo.Vi_user_student;

public interface Vi_user_studentMapper {

	// 查询所有
	@Select("select * from vi_user_student")
	public List<Vi_user_student> all();

	// 查询单个
	@Select("select * from vi_user_student where uid=#{uid}")
	public Vi_user_student selectByUid(int uid);
	
	//分页查询所有学员信息，一页显示8个
	@Select("select * from vi_user_student order by uid limit #{page},8")
	public List<Vi_user_student> showStudentList(int page);
	
	//查询总数
	@Select("select COUNT(*) from vi_user_student")
	public int totalPage();

}
